package com.aifund.common.dao;

import com.aifund.common.entity.UserFollowRobot;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface UserFollowRobotDao extends JpaRepository<UserFollowRobot,Long> {

    @Query(nativeQuery = true,value = "select count(*) from user_follow_robot where is_del = 0 and robot_id = ?1 and status = ?2")
    Integer getCountByRobotIdAndStatus(Long robotIb,int status);

}

